home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
The 640 MEG Shareware Studio 2
/
The 640 Meg Shareware Studio CD-ROM Volume II (Data Express)(1993).ISO
/
ss
/
123tutr1.zip
/
MENU2.DAT
< prev
next >
Wrap
Text File
|
1991-03-11
|
10KB
|
329 lines
24
Worksheet Range Copy Move File Print Graph Data System Quit
Global Insert Delete Column Erase Titles Window Status Page
Format Label-Prefix Column-Width Recalculation Protection Default Zero
Fixed Scientific Currency , General +/- Percent Date Text Hidden
Left Right Center
Column Row
Format Label Erase Name Justify Protect Unprotect Input Value Transpose
Create Delete Labels Reset Table
Horizontal Vertical Sync Unsync Clear
Both Horizontal Vertical Clear
1 (DD-MMM-YY) 2 (DD-MMM) 3 (MMM-YY) 4 (Long Intn'l) 5 (Short Intn'l) Time
Fill Table Sort Query Distribution Matrix Regression Parse
1 2 Reset
Data-Range Primary-Key Secondary-Key Reset Go Quit
Input Criterion Output Find Extract Unique Delete Reset Quit
Type X A B C D E F Reset View Save Options Name Quit
Line Bar XY Stacked-Bar Pie
Retrieve Save Combine Xtract Erase List Import Directory
Formulas Values
Copy Add Subtract
Entire-File Named/Specified-Range
Worksheet Print Graph Other
Text Numbers
Fixed Scientific Currency , General +/- Percent Date Text Hidden Reset
9,2,1,1,Worksheet
Global, Insert, Delete, Column, Erase, Titles, Window, Status, Page
1,3,12,1,Range
Format, Label, Erase, Name, Justify, Protect, Unprotect, Input, Value, Transpose
2,4,19,1,Copy
Copy a cell or range of cells
3,5,25,1,Move
Move a cell or range of cells
4,6,31,1,File
Retrieve, Save, Combine, Xtract, Erase, List, Import, Directory
5,7,37,1,Print
Output a range to the printer or a print file
6,8,44,1,Graph
Create a graph
7,137,51,1,Data
Fill, Table, Sort, Query, Distribution, Matrix, Regression, Parse
137,1,65,1,Quit
End 1-2-3 session (Have you saved your work ?)
138,11,1,2,Global
Set worksheet settings
10,12,9,2,Insert
Insert blank column(s) or row(s)
11,13,17,2,Delete
Delete entire column(s) or row(s)
12,14,25,2,Column
Set display characteristics of the current column
13,15,33,2,Erase
Erase the entire worksheet
14,16,40,2,Titles
Set horizontal or vertical titles
15,17,48,2,Window
Set split screen and synchronized scrolling
16,138,56,2,Status
Display worksheet settings
139,19,1,3,Format
Set global format
18,20,9,3,Label-Prefix
Set global label alignment prefix (Left, Right, Center)
19,21,23,3,Column-Width
Set global column width
20,22,37,3,Recalculation
Natural, Columnwise, Rowwise, Automatic, Manual, Iteration
21,23,52,3,Protection
Turn protection on or off
22,139,64,3,Default
Define default disk and printer settings
140,25,1,4,Fixed
Fixed number of decimal places (x.xx)
24,26,8,4,Scientific
Exponential format (x.xxE+xx)
25,27,20,4,Currency
Currency format ($x,xxx.xx)
26,28,30,4,comma
Commas inserted; negative values in parenthesis (x,xxx.xx)
27,29,33,4,General
Standard format (x.xx or x.xxExx)
28,30,42,4,+/-
Horizontal bar graph format (+++ or ---)
29,31,47,4,Percent
Percent format (x.xx%)
30,32,56,4,Date
Date formats
31,140,62,4,Text
Display formula instead of value
35,34,1,5,Left
Align labels with left edges of cells
33,35,7,5,Right
Align labels with right edges of cells
34,33,14,5,Center
Center labels in cells
37,37,1,6,Column
Insert one or more blank columns to the left of the cell pointer
36,36,9,6,Row
Insert one or more blank rows above the cell pointer
39,39,1,6,Column
Delete one or more columns
38,38,9,6,Row
Delete one or more rows
142,41,1,7,Format
Format a cell or range of cells
40,42,9,7,Label
Align a label or range of labels (Left, Right, or Center)
41,43,16,7,Erase
Erase a cell or range of cells
42,44,23,7,Name
Create, delete, or modify range names
43,45,29,7,Justify
Adjust width of a column of labels
44,46,38,7,Protect
Disallow changes to a range if protection is enabled
45,47,47,7,Unprotect
Allow changes to a range
46,141,58,7,Input
Enter data into the unprotected cells in a range
143,49,1,8,Create
Create or modify a range name
48,50,9,8,Delete
Delete a range name
49,51,17,8,Labels
Create names from a range of labels
50,143,25,8,Reset
Delete all range names
56,53,1,9,Horizontal
Split the screen horizontally at the current row
52,54,13,9,Vertical
Split the screen vertically at the current column
53,55,23,9,Sync
Synchronize scrolling
54,56,29,9,Unsync
Unsynchronize scrolling
55,52,37,9,Clear
Eliminate split screen display
60,58,1,10,Both
Set both horizontal and vertical titles
57,59,7,10,Horizontal
Freeze all rows above the cell pointer
58,60,19,10,Vertical
Freeze all columns to the left of the cell pointer
59,57,29,10,Clear
Eliminate horizontal and vertical titles
136,127,76,24,Reset
Use global format
150,63,1,11,1 (DD-MMM-YY)
Lotus standard long form
62,64,16,11,2 (DD-MMM)
Lotus standard short form
63,148,28,11,3 (MMM-YY)
Lotus standard short form
146,66,1,12,Fill
Fill a range with numbers
65,67,7,12,Table
Create a table of values
66,68,14,12,Sort
Sort data records
67,69,20,12,Query
Find all data records satisfying given criteria
68,144,27,12,Distribution
Calculate frequency distribution of a range
72,71,1,13,1
One input cell, one or more dependent formulas
70,72,4,13,2
Two input cells, one dependent formula
71,70,7,13,Reset
Reset table ranges and disable TABLE key
78,74,1,14,Data-Range
Specify records to be sorted
73,75,13,14,Primary-Key
Specify Primary sort key column
74,76,26,14,Secondary-Key
Specify Secondary sort key column
75,77,41,14,Reset
Cancel sort range and keys
76,78,48,14,Go
Perform sort and return to READY mode
77,73,52,14,Quit
Return to READY mode
87,80,1,15,Input
Set the range containing data records
79,81,8,15,Criterion
Set the range containing criteria
80,82,19,15,Output
Set the range to which extracted records are copied
81,83,27,15,Find
Highlight each record matching criteria
82,84,33,15,Extract
Copy all records that match criteria to Output range
83,85,42,15,Unique
Copy all records that match criteria to Output range, eliminating duplicates
84,86,50,15,Delete
Delete all records that match criteria
85,87,58,15,Reset
Cancel Input, Criterion, and Output ranges
86,79,65,15,Quit
Return to READY mode
101,89,1,16,Type
Set graph type
88,90,7,16,X
Set X-range
89,91,10,16,A
Set first data range
90,92,13,16,B
Set second data range
91,93,16,16,C
Set third data range
92,94,19,16,D
Set fourth data range
93,95,22,16,E
Set fifth data range
94,96,25,16,F
Set sixth data range
95,97,28,16,Reset
Cancel graph settings
96,98,35,16,View
View the current graph
97,99,41,16,Save
Save the current graph in a file for later printing
98,100,47,16,Options
Legend, Format, Titles, Grid, Scale, Color, B&W, Data-Labels
99,101,56,16,Name
Use, Create, Delete, or Reset named graphs
100,88,62,16,Quit
Return to READY mode
106,103,1,17,Line
Line graph
102,104,7,17,Bar
Bar graph
103,105,12,17,XY
XY graph
104,106,16,17,Stacked-Bar
Stacked bar graph
105,102,29,17,Pie
Pie chart
114,108,1,18,Retrieve
Erase the current worksheet and display the selected worksheet
107,109,11,18,Save
Store the entire worksheet in a worksheet file
108,110,17,18,Combine
Incorporate all or part of a worksheet file into the worksheet
109,111,26,18,Xtract
Store a cell range in a worksheet file
110,112,34,18,Erase
Erase a worksheet, print, or graph file
111,113,41,18,List
Display names of 1-2-3 files in current directory
112,114,47,18,Import
Read text or numbers from a print file into the worksheet
113,107,55,18,Directory
Display and/or set the current directory
116,116,1,19,Formulas
Save formulas
115,115,11,19,Values
Save current formula values only
119,118,1,20,Copy
Replace cells in worksheet with cell from file
117,119,7,20,Add
Add values from file to values in worksheet
118,117,12,20,Subtract
Subtract values from file from values in worksheet
121,121,1,21,Entire-File
Incorporate entire file into worksheet
120,120,14,21,Named/Specified-Range
Incorporate a named or coordinate specified range from file into worksheet
147,123,1,22,Worksheet
Display the names of all worksheet files in current directory
122,124,12,22,Print
Display the names of all print files in current directory
123,147,19,22,Graph
Display the names of all graph files in current directory
126,126,1,23,Text
Enter each line of file as a single label
125,125,7,23,Numbers
Treat each line as numbers and quoted labels
61,128,1,24,Fixed
Fixed number of decimal places (x.xx)
127,129,8,24,Scientific
Exponential format (x.xxE+xx)
128,130,20,24,Currency
Currency format ($x,xxx.xx)
129,131,30,24,comma
Commas inserted; negative values in parenthesis (x,xxx.xx)
130,132,33,24,General
Standard format (x.xx or x.xxExx)
131,133,42,24,+/-
Horizontal bar graph format (+++ or ---)
132,134,47,24,Percent
Percent format (x.xx%)
133,135,56,24,Date
Date formats
134,136,62,24,Text
Display formula instead of value
135,61,68,24,Hidden
Suppress cell display
8,9,57,1,System
Invoke the DOS Command Interpreter
17,10,64,2,Page
Insert a page-break above the cell pointer
23,18,73,3,Zero
Turn zero suppression on or off
32,24,68,4,Hidden
Suppress cell display
47,142,65,7,Value
Copy range, converting formulas to values
141,40,72,7,Transpose
Copy range, switching columns and rows
51,48,32,8,Table
Create table of range names
69,145,41,12,Matrix
Perform matrix operations
144,146,49,12,Regression
Calculate linear regressions
145,65,61,12,Parse
Parse a column of labels into a range
124,122,26,22,Other
Display the names of all files in the current directory
64,149,40,11,4 (Long Intn'l)
Currently configured: MM/DD/YY
148,150,57,11,5 (Short Intn'l)
Currently configured: MM/DD
149,62,75,11,Time
Time formats
X999
X999